﻿create table dbo.RoleAuthorizes (
   RoleAuthorizeId      nvarchar(10)         collate Chinese_PRC_CI_AS not null,
   RoleId               nvarchar(10)         collate Chinese_PRC_CI_AS null,
   AuthorizeCodeId      nvarchar(10)         collate Chinese_PRC_CI_AS null,
   constraint PK_RoleAuthorizes primary key (RoleAuthorizeId)
         on "PRIMARY"
)
on "PRIMARY"
go

execute sp_addextendedproperty 'MS_Description', 
   '角色授权ID',
   'user', 'dbo', 'table', 'RoleAuthorizes', 'column', 'RoleAuthorizeId'
go

execute sp_addextendedproperty 'MS_Description', 
   '角色ID',
   'user', 'dbo', 'table', 'RoleAuthorizes', 'column', 'RoleId'
go

execute sp_addextendedproperty 'MS_Description', 
   '授权ID',
   'user', 'dbo', 'table', 'RoleAuthorizes', 'column', 'AuthorizeCodeId'
go